Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

Use ASCII code and offset

Since A is ASCII 65, you can use an offset of 64 to calculate the column letter based on your number.

columnLetter = Chr$(64 + columnNumber)


Feedback response number WEBB9DALHN created by ~Dan Kikiterobu on 11/09/2013

Creating an Excel file (~Sigmund Bubjip... 8.Nov.13)
. . Use ASCII code and offset (~Dan Kikiterobu... 9.Nov.13)
. . . . limted to first 26 (~Sigmund Bubjip... 11.Nov.13)
. . . . . . You can select cells by row and col... (~Bella Kinilyad... 11.Nov.13)
. . . . . . . . thanks (~Sigmund Bubjip... 12.Nov.13)
. . Why reinvent the wheel? (~Martha Lopjipy... 11.Nov.13)
. . . . use of NumberFormat (~Sigmund Bubjip... 12.Nov.13)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS